package com.xgpro.mapper.archives;

import com.xgpro.domain.archives.entity.SixSigma;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

public interface SixSigmaMapper extends Mapper<SixSigma> {




    @Select("<script>" +
            " select id,six_sigma_grade as sixSigmaGrade,acquisition_time as acquisitionTime ,certificate_number as certificateNumber ," +
            " user_id as userId  " +
            " from t_six_sigma  " +
            " where " +
            " user_id=#{userId}" +
            " ORDER BY " +
            " acquisition_time" +
            " DESC LIMIT 1" +
            "</script>")
   SixSigma getSixSigma(Integer userId);
}
